1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class CauHinhHeThongMod
15 {
16
17 protected string KhoaChinh { get; set; }
18 protected string GiaTri { get; set; }
19 protected string TrangThai { get; set; }
20 protected string GhiChu { get; set; }
21
22
23 public CauHinhHeThongMod(string _KhoaChinh)
24 {
25 KhoaChinh = _KhoaChinh;
26 }
27
28 public CauHinhHeThongMod()
29 {
30
31 }
32
33 public CauHinhHeThongMod(string _KhoaChinh, string _GiaTri, string _TrangThai, string _GhiChu)
34 {
35 KhoaChinh = _KhoaChinh;
36 GiaTri = _GiaTri;
37 TrangThai = _TrangThai;
38 GhiChu = _GhiChu;
39 }
40
41 //Them moi dvt
42 public int InsertCauHinhHeThong()
43 {
44 int i = 0;
45 string[] paras = new string[4] { "@KhoaChinh", "@GiaTri", "@TrangThai", "@GhiChu" };
46 object[] values = new object[4] { KhoaChinh, GiaTri, TrangThai, GhiChu };
47 i = Models.connection.Excute_Sql("tbl_CauHinhHeThong_Insert", CommandType.StoredProcedure, paras, values);
48 return i;
49 }
50
51 //update mod don vi tinh
52 public int UpdateCauHinhHeThong()
53 {
54 int i = 0;
55 string[] paras = new string[4] { "@KhoaChinh", "@GiaTri", "@TrangThai", "@GhiChu" };
56 object[] values = new object[4] { KhoaChinh, GiaTri, TrangThai, GhiChu };
57 i = Models.connection.Excute_Sql("tbl_CauHinhHeThong_Update", CommandType.StoredProcedure, paras, values);
58 return i;
59 }
60
61 public int DeleteCauHinhHeThong()
62 {
63 int i = 0;
64 string[] paras = new string[1] { "@KhoaChinh" };
65 object[] values = new object[1] { KhoaChinh };
66 i = Models.connection.Excute_Sql("tbl_CauHinhHeThong_Delete", CommandType.StoredProcedure, paras, values);
67 return i;
68 }
69
70 //xoa du lieu demo
71 public int DeleteDuLieuDemo()
72 {
73 int i = 0;
74 string[] paras = new string[1] { "@KhoaChinh" };
75 object[] values = new object[1] { KhoaChinh };
76 i = Models.connection.Excute_Sql("tbl_CauHinhHeThong_DeleteDuLieuDemo", CommandType.StoredProcedure, paras, values);
77 return i;
78 }
79
80 public DataSet FillDataSet_getAllCauHinhHeThong()
81 {
82 DataSet ds = new DataSet();
83 ds = Models.connection.FillDataSet("tbl_CauHinhHeThong_GetAll", CommandType.StoredProcedure);
84 return ds;
85 }
86
87 public SqlDataReader DataReader_getAllCauHinh_HT()
88 {
89
90 SqlDataReader dtReader;
91 string[] paras = new string[1] { "@KhoaChinh" };
92 object[] values = new object[1] { KhoaChinh };
93 dtReader = Models.connection.DataReader("tbl_CauHinhHeThong_GetAll", CommandType.StoredProcedure, paras, values);
94 return dtReader;
95 }
96
97
98
99 }
100 }